package com.qf.mapper;

import com.qf.entity.Student;
import com.qf.entity.StudentVO;
import org.apache.ibatis.annotations.Mapper;

import java.util.List;
import java.util.Map;

@Mapper
public interface StudentMapper {
    Student findStuById(int id);

    List<Student> studentList();

    List<Student> listByMap(Map<Integer, String> map);

    int studentAdd(Student student);

    int studentUpdate(Student student);

    int studentDelete(int id);

    void deleteBatch(List<Integer> ids);

    List<StudentVO> findAllStudentAndClassroom();

    StudentVO findStudentAndAllSubjectByStuid(int sid);

    StudentVO findStudentAndAllSubjectAndTeacherByStuid(int sid);

    List<Integer> findAllSubjectId(int sid);
}
